SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_AddRecruitmentParticipants_apply2]
	(
	@param_recruitment int,
	@param_employing_unit VarChar(50),
	@param_user_add NVarchar(50),
	@param_add_time smalldatetime
	)

AS
	/* SET NOCOUNT ON */
	Declare @employer Int
	Set @employer=(Select JOL_Employer_No from JOL_Employer where JOL_Employer_Account=@param_employing_unit)
	insert into dbo.JOL_Recruitment_Participants_apply
	(
	 recruitment,
	 employing_unit,
	 booth_quantity,
	 booth_arrange ,
	 remark_recruitment ,
	 contactperson ,
	 mobile ,
	 email ,
	 phone,
	 fax,
	 is_payment,
	 is_need_invoice,
	 invoice_beginning ,
	 invoice_item,
	 add_time ,
	 user_add ,
	 state,
	 user_check,
	 remark_invoice,
	 is_visible
	
	)
	values
	(
	@param_recruitment,
	@employer,
	0,
	'',
	'',
	'' ,
	'' ,
	'' ,
	'',
	'',
	'False',
	'False',
	'' ,
	'',
	@param_add_time ,
	@param_user_add ,
	'False',
	'',
	'',
	'False'
	)
	RETURN
GO
